<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<meta http-equiv="X-UA-Compatible" content="IE=9"/>
<title>AMBHAS: /home/tomer/svn/ambhas/ambhas/xls.py Source File</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />
<link href="navtree.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="resize.js"></script>
<script type="text/javascript" src="navtree.js"></script>
<script type="text/javascript">
  $(document).ready(initResizable);
</script>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>

</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">AMBHAS
   
   </div>
   
  </td>
  
  
  
   
   <td>        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
</td>
   
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.7.6.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
</div>
<div id="side-nav" class="ui-resizable side-nav-resizable">
  <div id="nav-tree">
    <div id="nav-tree-contents">
    </div>
  </div>
  <div id="splitbar" style="-moz-user-select:none;" 
       class="ui-resizable-handle">
  </div>
</div>
<script type="text/javascript">
  initNavTree('xls_8py.html','');
</script>
<div id="doc-content">
<div class="header">
  <div class="headertitle">
<div class="title">xls.py</div>  </div>
</div><!--header-->
<div class="contents">
<a href="xls_8py.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a><a class="code" href="namespaceambhas_1_1xls.html">00001</a> <span class="comment"># -*- coding: utf-8 -*-</span>
<a name="l00002"></a>00002 <span class="stringliteral">&quot;&quot;&quot;</span>
<a name="l00003"></a>00003 <span class="stringliteral">Created on Fri Nov 11 16:49:46 2011</span>
<a name="l00004"></a>00004 <span class="stringliteral"></span>
<a name="l00005"></a>00005 <span class="stringliteral">@author: Sat Kumar Tomer</span>
<a name="l00006"></a>00006 <span class="stringliteral">@website: www.ambhas.com</span>
<a name="l00007"></a>00007 <span class="stringliteral">@email: satkumartomer@gmail.com</span>
<a name="l00008"></a>00008 <span class="stringliteral">&quot;&quot;&quot;</span>
<a name="l00009"></a>00009 
<a name="l00010"></a>00010 <span class="keyword">import</span> xlrd, xlwt
<a name="l00011"></a>00011 <span class="keyword">import</span> numpy <span class="keyword">as</span> np
<a name="l00012"></a>00012 
<a name="l00013"></a><a class="code" href="classambhas_1_1xls_1_1xlsread.html">00013</a> <span class="keyword">class </span><a class="code" href="classambhas_1_1xls_1_1xlsread.html">xlsread</a>():
<a name="l00014"></a>00014     <span class="stringliteral">&quot;&quot;&quot;</span>
<a name="l00015"></a>00015 <span class="stringliteral">    A class to read data from xls file</span>
<a name="l00016"></a>00016 <span class="stringliteral">    based on the &#39;xlrd&#39;</span>
<a name="l00017"></a>00017 <span class="stringliteral">    </span>
<a name="l00018"></a>00018 <span class="stringliteral">    Example:</span>
<a name="l00019"></a>00019 <span class="stringliteral">            fname = &#39;/home/tomer/rain_projection/raw_data/a2_0.5.xls&#39;</span>
<a name="l00020"></a>00020 <span class="stringliteral">            foo = xlsread(fname)</span>
<a name="l00021"></a>00021 <span class="stringliteral">            var = foo.get_cells(&#39;a3:a5&#39;, &#39;Sheet1&#39;)</span>
<a name="l00022"></a>00022 <span class="stringliteral">    &quot;&quot;&quot;</span>
<a name="l00023"></a>00023     
<a name="l00024"></a><a class="code" href="classambhas_1_1xls_1_1xlsread.html#a870ac3c45bd6c0274a200ddcd358cfd0">00024</a>     <span class="keyword">def </span><a class="code" href="classambhas_1_1xls_1_1xlsread.html#a389922c87e68aca426347c6111299f52">__init__</a>(self, fname):
<a name="l00025"></a>00025         self.<a class="code" href="classambhas_1_1xls_1_1xlsread.html#a436c9ddc7f511c7f57248d6ad78ded08">fname</a> = fname
<a name="l00026"></a>00026         book = xlrd.open_workbook(self.<a class="code" href="classambhas_1_1xls_1_1xlsread.html#a436c9ddc7f511c7f57248d6ad78ded08">fname</a>)
<a name="l00027"></a>00027         self.<a class="code" href="classambhas_1_1xls_1_1xlsread.html#a870ac3c45bd6c0274a200ddcd358cfd0">sheet_names</a> = book.sheet_names()
<a name="l00028"></a>00028         self.<a class="code" href="classambhas_1_1xls_1_1xlsread.html#a42ce716fa3632a8b7ad55283cbdb2c45">book</a> = book
<a name="l00029"></a>00029                 
<a name="l00030"></a><a class="code" href="classambhas_1_1xls_1_1xlsread.html#ae4fa5f51568a151c358d68812bb2b97b">00030</a>     <span class="keyword">def </span><a class="code" href="classambhas_1_1xls_1_1xlsread.html#ae4fa5f51568a151c358d68812bb2b97b">get_cells</a>(self, cell_range, sheet):
<a name="l00031"></a>00031         <span class="stringliteral">&quot;&quot;&quot;</span>
<a name="l00032"></a>00032 <span class="stringliteral">        cell_range: a single cell i.e. &#39;a2&#39;</span>
<a name="l00033"></a>00033 <span class="stringliteral">                    range of cells i.e. &#39;a2:f5&#39;</span>
<a name="l00034"></a>00034 <span class="stringliteral">        sheet:  name of the sheet, must be string</span>
<a name="l00035"></a>00035 <span class="stringliteral">        &quot;&quot;&quot;</span>
<a name="l00036"></a>00036         book = self.<a class="code" href="classambhas_1_1xls_1_1xlsread.html#a42ce716fa3632a8b7ad55283cbdb2c45">book</a>
<a name="l00037"></a>00037         sheet = book.sheet_by_name(sheet)
<a name="l00038"></a>00038         
<a name="l00039"></a>00039         <span class="keywordflow">if</span> <span class="stringliteral">&#39;:&#39;</span> <span class="keywordflow">not</span> <span class="keywordflow">in</span> cell_range:
<a name="l00040"></a>00040             foo1 = cell_range
<a name="l00041"></a>00041             row,col = self.<a class="code" href="classambhas_1_1xls_1_1xlsread.html#a68e89b1b25c7a746bfab2b799c1d6c0c">__cell2ind__</a>(foo1)
<a name="l00042"></a>00042             data = sheet.cell_value(row,col)
<a name="l00043"></a>00043         <span class="keywordflow">else</span>:
<a name="l00044"></a>00044             foo1, foo2 = cell_range.split(<span class="stringliteral">&#39;:&#39;</span>)
<a name="l00045"></a>00045             row1,col1 = self.<a class="code" href="classambhas_1_1xls_1_1xlsread.html#a68e89b1b25c7a746bfab2b799c1d6c0c">__cell2ind__</a>(foo1)
<a name="l00046"></a>00046             row2,col2 = self.<a class="code" href="classambhas_1_1xls_1_1xlsread.html#a68e89b1b25c7a746bfab2b799c1d6c0c">__cell2ind__</a>(foo2)
<a name="l00047"></a>00047             
<a name="l00048"></a>00048             <span class="keywordflow">if</span> row2&lt;row1:
<a name="l00049"></a>00049                 <span class="keywordflow">raise</span> Exception(<span class="stringliteral">&#39;row_start should be &lt;= row_end&#39;</span>)
<a name="l00050"></a>00050             <span class="keywordflow">if</span> col2&lt;col1:
<a name="l00051"></a>00051                 <span class="keywordflow">raise</span> Exception(<span class="stringliteral">&#39;col_start should be &lt;= col_end&#39;</span>)
<a name="l00052"></a>00052             
<a name="l00053"></a>00053             data = []
<a name="l00054"></a>00054             <span class="keywordflow">for</span> i <span class="keywordflow">in</span> range(row1,row2+1):
<a name="l00055"></a>00055                 data_row = []
<a name="l00056"></a>00056                 <span class="keywordflow">for</span> j <span class="keywordflow">in</span> range(col1,col2+1):
<a name="l00057"></a>00057                     <span class="keywordflow">if</span> sheet.cell_value(i,j): <span class="comment"># test if the cell is empty</span>
<a name="l00058"></a>00058                         data_row.append(sheet.cell_value(i,j))
<a name="l00059"></a>00059                     <span class="keywordflow">else</span>: 
<a name="l00060"></a>00060                         <span class="keywordflow">if</span> sheet.cell_value(i,j) == 0:
<a name="l00061"></a>00061                             <span class="comment"># if the cell is zero fill with zeros</span>
<a name="l00062"></a>00062                             data_row.append(sheet.cell_value(i,j))
<a name="l00063"></a>00063                         <span class="keywordflow">else</span>:
<a name="l00064"></a>00064                             <span class="comment"># if cell is empty fill with nan</span>
<a name="l00065"></a>00065                             data_row.append(np.nan)
<a name="l00066"></a>00066                     
<a name="l00067"></a>00067                 data.append(data_row)
<a name="l00068"></a>00068             
<a name="l00069"></a>00069         <span class="keywordflow">return</span> np.array(data)
<a name="l00070"></a>00070 
<a name="l00071"></a><a class="code" href="classambhas_1_1xls_1_1xlsread.html#a68e89b1b25c7a746bfab2b799c1d6c0c">00071</a>     <span class="keyword">def </span><a class="code" href="classambhas_1_1xls_1_1xlsread.html#a68e89b1b25c7a746bfab2b799c1d6c0c">__cell2ind__</a>(self,foo):
<a name="l00072"></a>00072         <span class="stringliteral">&quot;&quot;&quot;</span>
<a name="l00073"></a>00073 <span class="stringliteral">        given the cell number i.e. (AA100)</span>
<a name="l00074"></a>00074 <span class="stringliteral">        returns the row and column of cell in indices format i.e. 0, 10</span>
<a name="l00075"></a>00075 <span class="stringliteral">        &quot;&quot;&quot;</span>
<a name="l00076"></a>00076         
<a name="l00077"></a>00077         <span class="comment"># if the column is less than Z</span>
<a name="l00078"></a>00078         foo_str = foo[0].lower()
<a name="l00079"></a>00079         col = ord(foo_str)-ord(<span class="stringliteral">&#39;a&#39;</span>)
<a name="l00080"></a>00080         
<a name="l00081"></a>00081         <span class="comment"># if the column is more than Z, i.e. AA</span>
<a name="l00082"></a>00082         <span class="keywordflow">try</span>:
<a name="l00083"></a>00083             row = int(foo[1:])-1
<a name="l00084"></a>00084         <span class="keywordflow">except</span>:
<a name="l00085"></a>00085             row = int(foo[2:])-1
<a name="l00086"></a>00086             foo_str = foo[1].lower()
<a name="l00087"></a>00087             col = (col+1)*26+ ord(foo_str)-ord(<span class="stringliteral">&#39;a&#39;</span>)
<a name="l00088"></a>00088         
<a name="l00089"></a>00089         <span class="keywordflow">return</span> row, col
<a name="l00090"></a>00090 
<a name="l00091"></a>00091 
<a name="l00092"></a><a class="code" href="classambhas_1_1xls_1_1xlswrite.html">00092</a> <span class="keyword">class </span><a class="code" href="classambhas_1_1xls_1_1xlswrite.html">xlswrite</a>():
<a name="l00093"></a>00093     <span class="stringliteral">&quot;&quot;&quot;</span>
<a name="l00094"></a>00094 <span class="stringliteral">    This saves the array in xls format</span>
<a name="l00095"></a>00095 <span class="stringliteral"></span>
<a name="l00096"></a>00096 <span class="stringliteral">    Example:</span>
<a name="l00097"></a>00097 <span class="stringliteral">    var = np.array([[5,10,12],[2,5,6]])</span>
<a name="l00098"></a>00098 <span class="stringliteral">    xls_out_file = xlswrite(var, &#39;f10&#39;, &#39;Sheet1&#39;)</span>
<a name="l00099"></a>00099 <span class="stringliteral">    fname = &#39;/home/tomer/data.xls&#39;</span>
<a name="l00100"></a>00100 <span class="stringliteral">    foo1.save(fname)</span>
<a name="l00101"></a>00101 <span class="stringliteral">    &quot;&quot;&quot;</span>
<a name="l00102"></a>00102     
<a name="l00103"></a><a class="code" href="classambhas_1_1xls_1_1xlswrite.html#a3eab762bba1cb2b2cd240aefecf3411b">00103</a>     <span class="keyword">def </span><a class="code" href="classambhas_1_1xls_1_1xlswrite.html#a09449e95ab369679681d99061d98f7de">__init__</a>(self, data, cell_start, sheet):
<a name="l00104"></a>00104         self.<a class="code" href="classambhas_1_1xls_1_1xlswrite.html#a3eab762bba1cb2b2cd240aefecf3411b">data</a> = data
<a name="l00105"></a>00105         self.<a class="code" href="classambhas_1_1xls_1_1xlswrite.html#a92dd76155420a59b21279c07c1031b27">cell_start</a> = cell_start
<a name="l00106"></a>00106         
<a name="l00107"></a>00107         <span class="comment"># initialize the xlwt     </span>
<a name="l00108"></a>00108         book = xlwt.Workbook()
<a name="l00109"></a>00109         sheet = book.add_sheet(sheet)
<a name="l00110"></a>00110         
<a name="l00111"></a>00111         <span class="comment"># convert into row and col        </span>
<a name="l00112"></a>00112         row, col = self.<a class="code" href="classambhas_1_1xls_1_1xlswrite.html#a910a92edf65094f06c3a5f9151321eee">__cell2ind__</a>(cell_start)
<a name="l00113"></a>00113         
<a name="l00114"></a>00114         <span class="keywordflow">if</span> isinstance(data, str)  <span class="keywordflow">or</span> isinstance(data, float) <span class="keywordflow">or</span> isinstance(data,int):
<a name="l00115"></a>00115             sheet.write(row,col,data)
<a name="l00116"></a>00116                 
<a name="l00117"></a>00117         <span class="keywordflow">if</span> data.ndim == 1:
<a name="l00118"></a>00118             <span class="keywordflow">for</span> i <span class="keywordflow">in</span> range(data.shape[0]):
<a name="l00119"></a>00119                 sheet.write(row+i,col, data[i])
<a name="l00120"></a>00120                 
<a name="l00121"></a>00121         <span class="keywordflow">else</span>:
<a name="l00122"></a>00122             <span class="keywordflow">for</span> i <span class="keywordflow">in</span> range(data.shape[0]):
<a name="l00123"></a>00123                 <span class="keywordflow">for</span> j <span class="keywordflow">in</span> range(data.shape[1]):
<a name="l00124"></a>00124                     sheet.write(row+i, col+j, data[i,j])
<a name="l00125"></a>00125         
<a name="l00126"></a>00126         self.<a class="code" href="classambhas_1_1xls_1_1xlswrite.html#adb892ded2db5ce0312d6c97bbe4e670a">book</a> = book
<a name="l00127"></a>00127     
<a name="l00128"></a>00128     
<a name="l00129"></a><a class="code" href="classambhas_1_1xls_1_1xlswrite.html#a8cb06f97553aec45e391e705d5140818">00129</a>     <span class="keyword">def </span><a class="code" href="classambhas_1_1xls_1_1xlswrite.html#a8cb06f97553aec45e391e705d5140818">save</a>(self, fname):
<a name="l00130"></a>00130         self.book.save(fname)
<a name="l00131"></a>00131     
<a name="l00132"></a>00132     
<a name="l00133"></a><a class="code" href="classambhas_1_1xls_1_1xlswrite.html#a910a92edf65094f06c3a5f9151321eee">00133</a>     <span class="keyword">def </span><a class="code" href="classambhas_1_1xls_1_1xlswrite.html#a910a92edf65094f06c3a5f9151321eee">__cell2ind__</a>(self, foo):
<a name="l00134"></a>00134         <span class="stringliteral">&quot;&quot;&quot;</span>
<a name="l00135"></a>00135 <span class="stringliteral">        given the cell number i.e. (AA100)</span>
<a name="l00136"></a>00136 <span class="stringliteral">        returns the row and column of cell in indices format i.e. 0,10</span>
<a name="l00137"></a>00137 <span class="stringliteral">        &quot;&quot;&quot;</span>
<a name="l00138"></a>00138         
<a name="l00139"></a>00139         <span class="comment"># if the column is less than Z</span>
<a name="l00140"></a>00140         foo_str = foo[0].lower()
<a name="l00141"></a>00141         col = ord(foo_str)-ord(<span class="stringliteral">&#39;a&#39;</span>)
<a name="l00142"></a>00142         
<a name="l00143"></a>00143         <span class="comment"># if the column is more than Z, i.e. AA</span>
<a name="l00144"></a>00144         <span class="keywordflow">try</span>:
<a name="l00145"></a>00145             row = int(foo[1:])-1
<a name="l00146"></a>00146         <span class="keywordflow">except</span>:
<a name="l00147"></a>00147             row = int(foo[2:])-1
<a name="l00148"></a>00148             foo_str = foo[1].lower()
<a name="l00149"></a>00149             col = (col+1)*26+ ord(foo_str)-ord(<span class="stringliteral">&#39;a&#39;</span>)
<a name="l00150"></a>00150         
<a name="l00151"></a>00151         <span class="keywordflow">return</span> row,col
<a name="l00152"></a>00152 
<a name="l00153"></a>00153 
<a name="l00154"></a><a class="code" href="classambhas_1_1xls_1_1xlswrite2.html">00154</a> <span class="keyword">class </span><a class="code" href="classambhas_1_1xls_1_1xlswrite2.html">xlswrite2</a>(<a class="code" href="classambhas_1_1xls_1_1xlswrite.html">xlswrite</a>):
<a name="l00155"></a>00155     <span class="stringliteral">&quot;&quot;&quot;</span>
<a name="l00156"></a>00156 <span class="stringliteral">    This saves the array in xls format</span>
<a name="l00157"></a>00157 <span class="stringliteral"></span>
<a name="l00158"></a>00158 <span class="stringliteral">    Example:</span>
<a name="l00159"></a>00159 <span class="stringliteral">    var = np.array([[5,10,12],[2,5,6]])</span>
<a name="l00160"></a>00160 <span class="stringliteral">    fname = &#39;/home/tomer/data.xls&#39;    </span>
<a name="l00161"></a>00161 <span class="stringliteral">    xls_out_file = xlswrite(fname)</span>
<a name="l00162"></a>00162 <span class="stringliteral">    xls_out_file.write(var, &#39;f10&#39;, &#39;Sheet1&#39;)</span>
<a name="l00163"></a>00163 <span class="stringliteral">    xls_out_file.save()</span>
<a name="l00164"></a>00164 <span class="stringliteral">    &quot;&quot;&quot;</span>
<a name="l00165"></a>00165     
<a name="l00166"></a><a class="code" href="classambhas_1_1xls_1_1xlswrite2.html#a73d40c45c5ed743d8840c0c2924e5230">00166</a>     <span class="keyword">def </span><a class="code" href="classambhas_1_1xls_1_1xlswrite2.html#ae0bb1fd46ebd328fa04a99e51ece35a0">__init__</a>(self, fname):
<a name="l00167"></a>00167         self.<a class="code" href="classambhas_1_1xls_1_1xlswrite2.html#a73d40c45c5ed743d8840c0c2924e5230">fname</a> = fname
<a name="l00168"></a>00168                 
<a name="l00169"></a>00169         <span class="comment"># initialize the xlwt     </span>
<a name="l00170"></a>00170         self.<a class="code" href="classambhas_1_1xls_1_1xlswrite2.html#a07695020ebc4279a3d4fe738254c7b74">book</a> = xlwt.Workbook()
<a name="l00171"></a>00171     
<a name="l00172"></a><a class="code" href="classambhas_1_1xls_1_1xlswrite2.html#a9eaa94875d2de2fa1a1413af8b18d668">00172</a>     <span class="keyword">def </span><a class="code" href="classambhas_1_1xls_1_1xlswrite2.html#a9eaa94875d2de2fa1a1413af8b18d668">write</a>(self, data, cell_start, sheet):
<a name="l00173"></a>00173         sheet = book.add_sheet(sheet)
<a name="l00174"></a>00174 
<a name="l00175"></a>00175         <span class="comment"># convert into row and col        </span>
<a name="l00176"></a>00176         row, col = self.__cell2ind__(cell_start)
<a name="l00177"></a>00177 
<a name="l00178"></a>00178         <span class="keywordflow">if</span> isinstance(data, str)  <span class="keywordflow">or</span> isinstance(data, float) <span class="keywordflow">or</span> isinstance(data,int):
<a name="l00179"></a>00179             sheet.write(row,col,data)
<a name="l00180"></a>00180                 
<a name="l00181"></a>00181         <span class="keywordflow">if</span> data.ndim == 1:
<a name="l00182"></a>00182             <span class="keywordflow">for</span> i <span class="keywordflow">in</span> range(data.shape[0]):
<a name="l00183"></a>00183                 sheet.write(row+i,col, data[i])
<a name="l00184"></a>00184                 
<a name="l00185"></a>00185         <span class="keywordflow">else</span>:
<a name="l00186"></a>00186             <span class="keywordflow">for</span> i <span class="keywordflow">in</span> range(data.shape[0]):
<a name="l00187"></a>00187                 <span class="keywordflow">for</span> j <span class="keywordflow">in</span> range(data.shape[1]):
<a name="l00188"></a>00188                     sheet.write(row+i, col+j, data[i,j])
<a name="l00189"></a>00189 
<a name="l00190"></a>00190     
<a name="l00191"></a><a class="code" href="classambhas_1_1xls_1_1xlswrite2.html#abd47fd75780988b5d7949b6c6197992b">00191</a>     <span class="keyword">def </span><a class="code" href="classambhas_1_1xls_1_1xlswrite2.html#abd47fd75780988b5d7949b6c6197992b">save</a>(self):
<a name="l00192"></a>00192         self.book.save(self.<a class="code" href="classambhas_1_1xls_1_1xlswrite2.html#a73d40c45c5ed743d8840c0c2924e5230">fname</a>)
<a name="l00193"></a>00193 
<a name="l00194"></a>00194 
<a name="l00195"></a>00195 <span class="keywordflow">if</span> __name__ == <span class="stringliteral">&quot;__main__&quot;</span>:
<a name="l00196"></a>00196     
<a name="l00197"></a>00197     <span class="comment"># read the data</span>
<a name="l00198"></a><a class="code" href="namespaceambhas_1_1xls.html#abedcf602fdc972f0ed55217e46f390bd">00198</a>     fname = <span class="stringliteral">&#39;/home/tomer/rain_projection/raw_data/a2_0.5.xls&#39;</span>
<a name="l00199"></a>00199         
<a name="l00200"></a><a class="code" href="namespaceambhas_1_1xls.html#a5d3f708f5a4b51a1725511f4792b7c56">00200</a>     foo = <a class="code" href="classambhas_1_1xls_1_1xlsread.html">xlsread</a>(fname)
<a name="l00201"></a><a class="code" href="namespaceambhas_1_1xls.html#a51050c7947cb486f30ce9732935989a2">00201</a>     var = foo.get_cells(<span class="stringliteral">&#39;a3:a5&#39;</span>, <span class="stringliteral">&#39;Sheet1&#39;</span>)
<a name="l00202"></a>00202     
<a name="l00203"></a><a class="code" href="namespaceambhas_1_1xls.html#af75f214c323cb9e897fcaccbdd5cb968">00203</a>     book = xlrd.open_workbook(fname)
<a name="l00204"></a><a class="code" href="namespaceambhas_1_1xls.html#acb3a8901bf9613399be1120c254843c6">00204</a>     sheet = book.sheet_by_name(<span class="stringliteral">&#39;Sheet1&#39;</span>)
<a name="l00205"></a>00205     sheet.cell_value(0,0)    
<a name="l00206"></a>00206     
<a name="l00207"></a>00207     <span class="keywordflow">print</span> var
<a name="l00208"></a>00208     
<a name="l00209"></a>00209     <span class="comment"># write the data</span>
<a name="l00210"></a>00210     var = np.array([[5,10,12],[2,5,6]])
<a name="l00211"></a><a class="code" href="namespaceambhas_1_1xls.html#aba04420022f8e433401bb03bbdec514e">00211</a>     foo1 = <a class="code" href="classambhas_1_1xls_1_1xlswrite.html">xlswrite</a>(var, <span class="stringliteral">&#39;f10&#39;</span>, <span class="stringliteral">&#39;Sheet1&#39;</span>)
<a name="l00212"></a>00212     fname = <span class="stringliteral">&#39;/home/tomer/data.xls&#39;</span>
<a name="l00213"></a>00213     foo1.save(fname)
<a name="l00214"></a>00214     
<a name="l00215"></a>00215     
<a name="l00216"></a>00216 
</pre></div></div><!-- contents -->
</div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Classes</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

  <div id="nav-path" class="navpath">
    <ul>
      <li class="navelem"><a class="el" href="xls_8py.html">xls.py</a>      </li>

    <li class="footer">Generated on Sat Jul 21 2012 12:26:08 for AMBHAS by
    <a href="http://www.doxygen.org/index.html">
    <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.7.6.1 </li>
   </ul>
 </div>


</body>
</html>
